create external table jms_dim.dim_sqs_project_customer_config_base (
  `id` bigint(20)  comment '主键id',
  `first_type_name` string  comment '一级项目名称',
  `first_type_code` string comment '一级项目编码',
  `second_type_name` string comment '二级项目名称',
  `customer_code` string comment '客户编码',
  `create_time` TIMESTAMP comment '创建时间',
  `update_time` TIMESTAMP comment '更新时间'

) comment'项目与客户信息关联表'
stored as parquet
 LOCATION
   '/dw/hive/jms_dim.db/external/dim_sqs_project_customer_config_base'
